Example of How to Make a Simple Database Using Xampp

Creating WEB Database
There are several steps that we should do in the process of making this database were:
    1. Creating a Database
  Steps - steps include:
                 a. Run xampp

b. Open the browser that we had then enter the URL "http: // localhost / phpmyadmin /" on the "create new database" content with a book or some other word then click "create".

c. Then fill in the "Name" with guest, or in other words later on "number of fields" content with the number of columns that we need.

d. There are three columns that need to be changed, namely "field (for the name of the data), type (type of data we want), length / values (many / long data)" and then select "save" to save and "go" to add

  

e. Display after successfully will be as below, the "id" double-click on the primary key.

 

f. A message will appear as below and click ok

 

g. After that will appear as below, double click on the sign of the black square.

h. Checklist in the "AUTO INCREMENT" and then save

 

i. Display after the save

 

j. Return to URL "http: // localhost / phpmyadmin /" select Privileges create a new user by clicking "add a new user"

 

 k.Lattice as below.

 

l. Back again to our database and then enter the first visitor data by clicking the "insert" as in the picture and then click "go" to save

 

m. Back to browse menus, the data that we create will appear as below.

 

Completed Data Base Simple
That's a short way to make a simple Data Base.

How to Make a Website, Easiest Way For Beginners

This article deliberately I wrote in response to questions of the beginner who just set foot in the world of web development. How to Make a Website. I'm sure a lot of visitors all who wonder about "How the hell do I make a website?". This is a global question that is so universal. Because in fact the website is the result of work completed as a single entity.Because a lot of stage-a stage in how to create a website where it requires you to learn the stage one by one, to be advanced because the exercises are being conducted repeatedly. Because of the way to create a website that is full of sacrifice is what makes you a man who advanced.

There are some things you need to know, two types of websites based on usage, 1. static website, 2. dynamic websites.
Static websiteWebsite of this type exist as a predecessor, no longer exist after the initial discovery of the Internet, because the technology per-website-an even begins with a static website, but now there are many companies that use these types of websites as a company profile form online. Where the company does not require any updates daily or weekly updates or news articles shaped. The most prominent of static websites is to change the content of a website you should know very well the programming language HTML & CSS and Javascript, because to perform the update, you must open the file and typing HTML codes and then save them back to the file type * .html , How to create a website as a very troublesome right? Indeed! And unnatural.
Dynamic websiteDynamic website until whenever will still be interesting in web development, because it contained a database. This database can be used for many different things, of course, contains information and contains articles, news, user information, and so forth. Examples of dynamic website is www.ilmuwebsite.com, facebook and google was an example of a dynamic website, or create a free website www.kaffah.biz service also uses these types of websites. This dynamic website is a fusion between the language used by a static website, ie HTML & CSS javascript along with language that is able to handle server and database management, better known by the server side language. What is included server side language? PHP with MySQL as the database, ASP.net with MySQL Server as the database, java servlet page with Oracle as the database and so forth. To update content, change the content of a website, you do not need to open a file and then change the contents of the file, in a dynamic website, you can simply just log in as admin, then please update the admin facility. Simple and fast. But the sacrifice is to create a website like this does take a long time, about three weeks - 2 months, depending on the complexity features of the website, and there are several programming languages ​​that you should know. How to make a website like this is recommended.

Stages First, you need to know in the beginning in how to make a website is how to create web pages simple, in which the links are connected between one page to another page, and then within that there is a picture / image / photo, you can learn a lot about how create a web in a variety of places.

but remember the more you read, the more references, the more you get, the more you smarter, increasing your level as a web developer, which have an impact on the more revenue you can get.

Stages Second, after you finished the stage to create a website first part you can make your website more attractive, giving the slide animation content, key changing, and effects animation 'wow', please learn Javascript, but my advice please directly learn javascript library, which is the best and easiest way JQuery.

Third Phase, after you finished the first stage and the second part to create a website, immediately proceed to in this section. This is the most serious stage, study the server side programming language, which can make you a reliable web developer, which is really serious.

Stages Fourth, once you learn how to create a website stage 1, 2 and 3, the next step is to learn PHP framework, like CodeIgniter. PHP Framework allows you to create large-scale applications, complex, and powerful, but it is much easier to make because of the concept of MVC in PHP Framework. For starters I suggest first learn CodeIgniter.

Stages Fifth, use your abilities combine everything, that in the end you will meet with technology ajax, xml, web services, programming web to mobile and so forth, it's all you can do with the basic strong, if the first stage to stage Finish the third already, and do not forget, practicing constantly, over and over again. How to create a website / web development is not instant. It took the sacrifice of time and energy.
Until you do not realize you've been at the top of your field of knowledge. :-).
Congratulations sweat, learn how to create a website steadily.
thank you...

 
 

How to Make a Simple Dynamic Web (PHP and MySQL) for beginners

Dynamic Web is a website where a user (client) can change the content of a specific page using a browser and the interaction between the user and the server is very complex.
Requests from users can be processed by the server which are then displayed with different contents vary according to the program flow. dynamic web allows you to change the data through the admin page without having to change kodingannya.
to create dynamic web language you can use php and mysql as the databas.

1. First you must have an application called xampp ie as a stand-alone server (localhost), you can download on the internet, to install it quite easy, just follow the instructions.

2. Once you have successfully installed the xampp, open the app and start "Apache" and "MySQL" and then open your browser recommended Firefox or Chrome. Then Type localhost / phpmyadmin in the address bar to process the mysql database

  3. Once the page appears phpMyAdmin, you first create a database with the name db_web, and then create a table for admin type the code below in SQL tab:

create table admin ( 

username varchar(15) not null primary key,

password varchar(15) not null,

level varchar(15) not null 

)

4. to make the web, you must first create a homepage first, open the editor like notepad or notepad ++ etc and then type / copy and paste the code below and name the file "index.php"

<!DOCTYPE HTML PUBLIC>  
<html>  
<head>  
<title>Kerangka Web</title>  
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
<link href="style.css" rel="stylesheet" type="text/css"> 
</head>  
  
<body>  
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">  
  <tr bgcolor="gray">  
    <td height="100" colspan="2"></td>  
  </tr>  
  <tr bgcolor="black">  
    <td colspan="2"><marquee onmouseover="this.stop()" onmouseout="this.start()" truespeed="true" scrollamount="1" scrolldelay="40" direction="left">  
    <strong><div id="login">Selamat Datang Di Website Kami, Website Ini Masih Dalam Tahap Pembuatan</div></strong>  
</marquee>  


</td>  
  </tr>  
  <tr>  
    <td width="200" height="600" valign="top" bgcolor="gray"><table width="200" border="0" cellspacing="0" cellpadding="0">  
      <tr>  
        <td><form name="form1" method="post" action="cek_login.php">  
          <table width="200" border="0" cellspacing="0" cellpadding="2">  
            <tr bgcolor="#003366">  
              <td height="30" colspan="2"><div align="center"><div id="login"><strong>Login Admin </strong></div></div></td>  
              </tr>  
            <tr>  
              <td width="74" height="30"><b>Username</b></td>  
              <td width="126">:   
                <input name="username" type="text" id="username" size="10"></td>  
            </tr>  
            <tr>  
              <td height="30"><b>Password</b></td>  
              <td>:   
                <input name="password" type="password" id="password" size="10"></td>  
            </tr>  
            <tr>  
              <td height="30">&nbsp;</td>  
              <td><input type="submit" name="Submit" value="Login"></td> 
            </tr>  
          </table>  
        </form>
       </td>  
      </tr>  
      <tr>  
        <td><div id="kiri">
<div id="login">
<p><center><b>PROFIL</center></p> 
<p>Nama : SAYHRUL RAMADAN </p>
<p>Web   : SYRAU.BLOGSPOT.CO.ID</p></b>
</div>
</div>
</td>  
      </tr>  
    </table> 
</td>   
    <td valign="top">&nbsp;</td>  
  </tr>  
  <tr bgcolor="black">  
    <td height="80" colspan="2"><div id="login"><center>Copyright 2015 <br>Design : Banu Ari Ramadhan</div></td>  
  </tr>  
</table>  
</body>  
</html>

5. To make the web interface looks nice, create css design for the web create a file called "style.css" and then type / copy and paste the code below:

explanation:
#kiri is to the left side of web design
#login is to design the writing on the login form


6. To see the results save the file "index.php" and "style.css" in C:> / xampp / htdocs / web (create a new folder named web) and then run it through your browser address bar by typing: localhost / web / index .php
then see the results ..
note: do not forget to activate your xampp (start Apache and MySQL)

you've made a simple homepage for the data to be displayed later ..
The next section I will post how to create connections to make the admin page

Thank you for visiting :)